-----------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  logtabA8.log
  log type:  text
 opened on:  17 Feb 2023, 16:16:58


. ///////////////////////////////////////
> ///// MAKE TABLE A8 ///////////////////
> ///////////////////////////////////////
> 
. 
. use "Enfranchisement and Representation 1919.dta", clear

. 
. 
. gen Denf_19_09=100*(reg19-reg09)/reg19

. gen Denf1=100*(reg13-reg09)/reg19

. gen Denf2=100*(reg19-reg13)/reg19

. 
. 
. gen estrema19=(soc19_pct+rif19_pct+rep19_pct+rad19_pct)

. 
. gen estrema09=(soc09_pct+rep09_pct+rad09_pct)

. 
. gen Destrema19_09=estrema19-estrema09

. 
. 
. gen DestremaMP19_09=estremaMP19-estremaMP09

. 
. 
. 
. gen op21p=100*op21/pop21

. gen op11p=100*op11/pop11

. gen Dop=op21p-op11p

. gen Dpop21=pop21-pop11

. 
. gen density21=100*abitantixkmq1921/pop21

. gen density11= 100*(abitantixkmq1911/pop11)

. gen Ddens=density21-density11

. 
. 
. gen poss11=100*poss11vol6tabxc/pop11

. gen poss21=100*poss21pag260relazionegenerale/pop21

. gen Dposs=poss21-poss11

. 
. gen agr_own11=100*contadini11/pop11

. gen agr_own21=100*contadini21/pop21

. 
. gen agr_not11=100*(totagr11-contadini11)/pop11

. gen agr_not21=100*(totagr21-contadini21)/pop21

. 
. gen Dagr_own=agr_own21-agr_own11

. gen Dagr_not=agr_not21-agr_not11

. 
. 
. gen ill21=100-alfabeti21

. gen ill11=100-alfabeti11

. 
. gen Dill=100*(ill21 - ill11)

. 
. 
. 
. 
. // Table A8
. 
. 
. reg  Destrema19_09 Denf_19_09 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_own11 ag
> r_not11, robust

Linear regression                               Number of obs     =         54
                                                F(12, 41)         =       1.78
                                                Prob > F          =     0.0851
                                                R-squared         =     0.1822
                                                Root MSE          =     15.257

------------------------------------------------------------------------------
             |               Robust
Destrema1~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
  Denf_19_09 |  -.5281508   .4019941    -1.31   0.196    -1.339994    .2836928
         Dop |    .075667   1.409832     0.05   0.957    -2.771546    2.922881
       Ddens |  -2717.247    2050.44    -1.33   0.192    -6858.193      1423.7
       Dposs |   4.405739   3.666475     1.20   0.236    -2.998858    11.81034
    Dagr_own |   .2143032   1.841447     0.12   0.908    -3.504575    3.933182
    Dagr_not |   .6286259   1.366891     0.46   0.648    -2.131865    3.389117
        Dill |  -.0050487   .0132962    -0.38   0.706    -.0319009    .0218035
       op11p |   .1284093   .7765468     0.17   0.869    -1.439859    1.696677
   density11 |  -57.90531   119.9058    -0.48   0.632    -300.0601    184.2495
      poss11 |   -.160699   1.305413    -0.12   0.903    -2.797034    2.475636
   agr_own11 |   .6864499   .9242461     0.74   0.462    -1.180103    2.553003
   agr_not11 |   .0084597   .6000737     0.01   0.989    -1.203414    1.220333
       _cons |   42.90383   44.25882     0.97   0.338    -46.47867    132.2863
------------------------------------------------------------------------------

. 
. xi:reg  Destrema19_09 Denf_19_09 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_own11
>  agr_not11 i.area, robust
i.area            _Iarea_1-4          (_Iarea_1 for area==C omitted)

Linear regression                               Number of obs     =         54
                                                F(15, 38)         =       1.66
                                                Prob > F          =     0.1029
                                                R-squared         =     0.2492
                                                Root MSE          =     15.185

------------------------------------------------------------------------------
             |               Robust
Destrema1~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
  Denf_19_09 |   -.837537   .4278063    -1.96   0.058    -1.703585    .0285115
         Dop |  -.7743285   1.583144    -0.49   0.628    -3.979235    2.430578
       Ddens |  -4031.459   2244.742    -1.80   0.080    -8575.701     512.784
       Dposs |   5.019756   3.984484     1.26   0.215    -3.046411    13.08592
    Dagr_own |  -2.097199   2.376677    -0.88   0.383     -6.90853    2.714132
    Dagr_not |   .6755937   1.253773     0.54   0.593    -1.862537    3.213724
        Dill |   -.007134   .0138393    -0.52   0.609    -.0351502    .0208822
       op11p |  -.3226767    .806342    -0.40   0.691    -1.955031    1.309677
   density11 |  -108.0119   116.9132    -0.92   0.361    -344.6903    128.6665
      poss11 |   -1.10871   1.448912    -0.77   0.449    -4.041879    1.824459
   agr_own11 |     1.8329   .9998849     1.83   0.075     -.191261    3.857062
   agr_not11 |   .0648574   .6161957     0.11   0.917    -1.182566     1.31228
    _Iarea_2 |  -.4134202   5.936656    -0.07   0.945    -12.43155    11.60471
    _Iarea_3 |   9.798474   6.207066     1.58   0.123    -2.767074    22.36402
    _Iarea_4 |   17.58218   7.621443     2.31   0.027     2.153378    33.01099
       _cons |   75.60466   48.29345     1.57   0.126    -22.16033    173.3696
------------------------------------------------------------------------------

. 
. reg  Destrema19_09 Denf1 Denf2 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_own11 a
> gr_not11, robust

Linear regression                               Number of obs     =         54
                                                F(13, 40)         =       1.38
                                                Prob > F          =     0.2137
                                                R-squared         =     0.2061
                                                Root MSE          =     15.218

------------------------------------------------------------------------------
             |               Robust
Destrema1~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
       Denf1 |  -.7828165   .3942256    -1.99   0.054    -1.579576    .0139432
       Denf2 |   .1777245   .8100549     0.22   0.827    -1.459458    1.814907
         Dop |  -.0690866   1.409479    -0.05   0.961    -2.917749    2.779576
       Ddens |  -2901.138   1957.166    -1.48   0.146    -6856.718    1054.443
       Dposs |   4.547412   3.595887     1.26   0.213    -2.720148    11.81497
    Dagr_own |   .1940452   1.799706     0.11   0.915    -3.443296    3.831387
    Dagr_not |   1.216882   1.507908     0.81   0.424    -1.830713    4.264477
        Dill |  -.0008588   .0149871    -0.06   0.955     -.031149    .0294313
       op11p |  -.0280202    .761626    -0.04   0.971    -1.567324    1.511283
   density11 |  -54.16517   122.9578    -0.44   0.662    -302.6722    194.3419
      poss11 |   -.273491   1.193293    -0.23   0.820    -2.685226    2.138244
   agr_own11 |   .9299361   .9371575     0.99   0.327    -.9641298    2.824002
   agr_not11 |   .1604946   .6764411     0.24   0.814    -1.206644    1.527633
       _cons |   44.29612   42.87966     1.03   0.308     -42.3669    130.9591
------------------------------------------------------------------------------

. 
. xi:reg  Destrema19_09 Denf1 Denf2 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_own1
> 1 agr_not11 i.area, robust
i.area            _Iarea_1-4          (_Iarea_1 for area==C omitted)

Linear regression                               Number of obs     =         54
                                                F(16, 37)         =       1.48
                                                Prob > F          =     0.1616
                                                R-squared         =     0.2623
                                                Root MSE          =     15.253

------------------------------------------------------------------------------
             |               Robust
Destrema1~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
       Denf1 |  -.9931686   .4586445    -2.17   0.037    -1.922471   -.0638665
       Denf2 |  -.2255265   .9165227    -0.25   0.807    -2.082578    1.631525
         Dop |  -.7452675   1.577943    -0.47   0.639    -3.942484    2.451949
       Ddens |  -3870.173   2237.515    -1.73   0.092     -8403.81    663.4636
       Dposs |   4.978812   3.868689     1.29   0.206    -2.859898    12.81752
    Dagr_own |  -1.962023   2.304449    -0.85   0.400     -6.63128    2.707234
    Dagr_not |   1.041567   1.442931     0.72   0.475    -1.882089    3.965223
        Dill |  -.0032478   .0162425    -0.20   0.843    -.0361581    .0296626
       op11p |  -.4909195   .8062406    -0.61   0.546    -2.124518    1.142679
   density11 |  -100.3195   122.9711    -0.82   0.420    -349.4825    148.8436
      poss11 |  -1.137488   1.373877    -0.83   0.413    -3.921227    1.646251
   agr_own11 |   1.921643   1.036363     1.85   0.072    -.1782285    4.021514
   agr_not11 |   .1631065      .6971     0.23   0.816    -1.249352    1.575565
    _Iarea_2 |  -2.982309   6.755514    -0.44   0.661    -16.67028    10.70566
    _Iarea_3 |   8.107038   7.153097     1.13   0.264    -6.386512    22.60059
    _Iarea_4 |   14.77599   8.378498     1.76   0.086    -2.200464    31.75244
       _cons |   75.00653   48.84749     1.54   0.133     -23.9679     173.981
------------------------------------------------------------------------------

. 
. reg  DestremaMP19_09 Denf_19_09 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_own11 
> agr_not11, robust

Linear regression                               Number of obs     =         54
                                                F(12, 41)         =       5.11
                                                Prob > F          =     0.0000
                                                R-squared         =     0.4779
                                                Root MSE          =     1.9393

------------------------------------------------------------------------------
             |               Robust
DestremaM~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
  Denf_19_09 |   -.072547   .0604597    -1.20   0.237    -.1946478    .0495537
         Dop |   .0348153   .2501267     0.14   0.890    -.4703258    .5399563
       Ddens |   -463.644   203.7446    -2.28   0.028    -875.1146   -52.17337
       Dposs |   .1658727   .3842529     0.43   0.668    -.6101419    .9418872
    Dagr_own |    .065184   .2336384     0.28   0.782    -.4066584    .5370264
    Dagr_not |   .0095322   .1360771     0.07   0.944    -.2652812    .2843455
        Dill |  -.0007931   .0012546    -0.63   0.531    -.0033269    .0017406
       op11p |   .1704823   .1617317     1.05   0.298    -.1561415    .4971061
   density11 |  -25.60471    15.3588    -1.67   0.103    -56.62243     5.41301
      poss11 |  -.1916478    .145884    -1.31   0.196    -.4862666    .1029709
   agr_own11 |   .2847898   .1331818     2.14   0.038     .0158237    .5537558
   agr_not11 |  -.0854829   .0827861    -1.03   0.308    -.2526728     .081707
       _cons |   7.460851   7.125417     1.05   0.301    -6.929221    21.85092
------------------------------------------------------------------------------

. 
. xi:reg  DestremaMP19_09 Denf_19_09 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_own
> 11 agr_not11 i.area, robust
i.area            _Iarea_1-4          (_Iarea_1 for area==C omitted)

Linear regression                               Number of obs     =         54
                                                F(15, 38)         =       4.35
                                                Prob > F          =     0.0001
                                                R-squared         =     0.4891
                                                Root MSE          =     1.9926

------------------------------------------------------------------------------
             |               Robust
DestremaM~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
  Denf_19_09 |  -.0603111    .072839    -0.83   0.413    -.2077659    .0871437
         Dop |   .0078485   .2578356     0.03   0.976    -.5141124    .5298094
       Ddens |  -573.1538    230.251    -2.49   0.017    -1039.273   -107.0349
       Dposs |    .138015   .4335045     0.32   0.752     -.739569    1.015599
    Dagr_own |   .0791546    .322396     0.25   0.807    -.5735019    .7318111
    Dagr_not |   .0413228   .1355938     0.30   0.762    -.2331725    .3158181
        Dill |  -.0010394   .0014269    -0.73   0.471    -.0039281    .0018493
       op11p |   .1545871   .1550465     1.00   0.325    -.1592881    .4684623
   density11 |  -24.73753   15.90125    -1.56   0.128    -56.92793    7.452871
      poss11 |  -.2411387   .1729329    -1.39   0.171    -.5912231    .1089457
   agr_own11 |   .3076272   .1434095     2.15   0.038     .0173099    .5979446
   agr_not11 |   -.087073   .0837227    -1.04   0.305    -.2565608    .0824148
    _Iarea_2 |   .4916384   1.128213     0.44   0.665    -1.792309    2.775586
    _Iarea_3 |   1.104989   .9369101     1.18   0.246    -.7916859    3.001665
    _Iarea_4 |   .4268246   1.050865     0.41   0.687    -1.700541    2.554191
       _cons |   6.554011   7.830818     0.84   0.408    -9.298651    22.40667
------------------------------------------------------------------------------

. 
. reg  DestremaMP19_09 Denf1 Denf2 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_own11
>  agr_not11, robust

Linear regression                               Number of obs     =         54
                                                F(13, 40)         =       4.14
                                                Prob > F          =     0.0003
                                                R-squared         =     0.4844
                                                Root MSE          =     1.9511

------------------------------------------------------------------------------
             |               Robust
DestremaM~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
       Denf1 |  -.0936636   .0589507    -1.59   0.120    -.2128074    .0254802
       Denf2 |  -.0140167   .1016793    -0.14   0.891    -.2195182    .1914848
         Dop |   .0228125   .2429116     0.09   0.926    -.4681301    .5137551
       Ddens |   -478.892   205.4097    -2.33   0.025    -894.0404   -63.74352
       Dposs |     .17762   .3812611     0.47   0.644    -.5929375    .9481775
    Dagr_own |   .0635042   .2380173     0.27   0.791    -.4175467    .5445552
    Dagr_not |   .0583097   .1582044     0.37   0.714    -.2614334    .3780527
        Dill |  -.0004457   .0013783    -0.32   0.748    -.0032314      .00234
       op11p |   .1575113   .1600901     0.98   0.331    -.1660429    .4810655
   density11 |  -25.29458   15.71614    -1.61   0.115    -57.05809    6.468924
      poss11 |  -.2010004   .1393586    -1.44   0.157    -.4826547    .0806539
   agr_own11 |   .3049793   .1377748     2.21   0.033     .0265262    .5834325
   agr_not11 |  -.0728763   .0896278    -0.81   0.421    -.2540209    .1082683
       _cons |   7.576297   7.043207     1.08   0.289    -6.658556    21.81115
------------------------------------------------------------------------------

. 
. xi:reg  DestremaMP19_09 Denf1 Denf2 Dop Ddens Dposs Dagr_own Dagr_not Dill  op11p density11 poss11 agr_ow
> n11 agr_not11 i.area, robust
i.area            _Iarea_1-4          (_Iarea_1 for area==C omitted)

Linear regression                               Number of obs     =         54
                                                F(16, 37)         =       3.55
                                                Prob > F          =     0.0007
                                                R-squared         =     0.4941
                                                Root MSE          =     2.0095

------------------------------------------------------------------------------
             |               Robust
DestremaM~09 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
       Denf1 |  -.0755069    .070067    -1.08   0.288    -.2174763    .0664624
       Denf2 |  -.0005547   .1323873    -0.00   0.997    -.2687969    .2676874
         Dop |    .010686   .2542353     0.04   0.967    -.5044436    .5258155
       Ddens |  -557.4059   238.0584    -2.34   0.025    -1039.758    -75.0537
       Dposs |   .1340172   .4244814     0.32   0.754    -.7260638    .9940983
    Dagr_own |   .0923531   .3218509     0.29   0.776    -.5597788     .744485
    Dagr_not |   .0770563   .1607919     0.48   0.635    -.2487391    .4028516
        Dill |    -.00066   .0016591    -0.40   0.693    -.0040215    .0027016
       op11p |     .13816   .1530392     0.90   0.372     -.171927    .4482469
   density11 |  -23.98644   16.64765    -1.44   0.158    -57.71778    9.744892
      poss11 |  -.2439485   .1672341    -1.46   0.153     -.582797       .0949
   agr_own11 |    .316292   .1462186     2.16   0.037     .0200251    .6125589
   agr_not11 |    -.07748   .0932411    -0.83   0.411    -.2664044    .1114444
    _Iarea_2 |   .2408133   1.269926     0.19   0.851    -2.332301    2.813928
    _Iarea_3 |   .9398384   1.071328     0.88   0.386    -1.230878    3.110555
    _Iarea_4 |    .152829    1.28076     0.12   0.906    -2.442237    2.747895
       _cons |   6.495611   7.879299     0.82   0.415    -9.469364    22.46059
------------------------------------------------------------------------------

. 
end of do-file

. log close
      name:  <unnamed>
       log:  C:\Users\larcines\Dropbox\Italian Election data\Paper\submission\jop_final\logtabA8.log
  log type:  text
 closed on:  17 Feb 2023, 16:17:55
-----------------------------------------------------------------------------------------------------------
